SQL/SQL Server DBA Multiple Choice Questions Sample Test,Sample questions

  1. Home
  2. Back

Question: 
 What is a MULTI_USER in SQL server?

1.users that have the appropriate permissions to connect to the database are allowed

2.One user at a time is allowed to connect to the database

3.Only some members are allowed to access the database

4.Only the system admin and some members are allowed to access the database

Posted Date:-2022-04-20 12:41:48

Question: 
 When SQL server is installed, which of the following databases are created by default?

1.Master

2.Model

3.Both a and b

4.Root

Posted Date:-2022-04-20 12:39:26

Question: 
 Which operation, when performed on a database can throw an error

1.The database could not be exclusively locked to perform the operation”

2.DELETE database

3.DROP database

4.Rename database

Posted Date:-2022-04-20 12:36:03

Question: 
CREATE DATABASE has how many mandatory parameters?

1.1

2.2

3.3

4.None of These

Posted Date:-2022-04-20 12:33:43

Question: 
For every unique constraint on a column, SQL server will create

1.Does not create an index

2.clustered index for that column

3.index for that column

4.non-clustered index for that column

Posted Date:-2022-04-20 12:34:34

Question: 
How do we delete a login?

1.DELETE LOGIN login_name

2.DROP LOGIN login_name

3.Login cannot be deleted but only disabled

4.DISABLE LOGIN login_name

Posted Date:-2022-04-20 12:32:44

Question: 
In which database state, the database is in single-user mode and may be repaired or restored.

1.OFFLINE

2.SUSPECT

3.EMERGENCY

4.All of the above

Posted Date:-2022-04-20 12:33:18

Question: 
What is the difference between ad-hoc queries from stored procedures?

1.Ad-hoc queries are placed embedded in the business logic code

2.Stored procedures are placed embedded in the business logic code

3.There is no difference as both are fired on the databases

4.None of above

Posted Date:-2022-04-20 12:43:32

Question: 
What is the syntax for creating a new login on the SQL server?

1.USE LOGIN login_id WITH PASSWORD password

2.CREATE LOGIN login_id WITH USE password

3.CREATE LOGIN login_id USE password

4.CREATE LOGIN login_id WITH PASSWORD password

Posted Date:-2022-04-20 12:37:19

Question: 
Which of the following below are valid database states?

1.OFFLINE

2.SUSPECT

3.EMERGENCY

4.All of the above

Posted Date:-2022-04-20 12:40:16

Question: 
Why type of user is the default in SQL server?

1.SINGLE_USER

2.MULTI_USER

3.RESTRICTED_USER

4.ROOT_USER

Posted Date:-2022-04-20 12:38:06

Posted on by R4R Team

More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL Basics
  20. MCQ | SQL Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!